<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class THourTempHumiS175430 extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('t_hour_TempHumi', function (Blueprint $table){
    $table->engine = 'InnoDB';
    $table->charset = 'utf8mb4';
    $table->collation = 'utf8mb4_unicode_ci';

    $table->increments("id")->nullable(false)->comment("");
$table->integer("pdi_index")->nullable(false)->comment("设备编号");
$table->date("at_date")->nullable(false)->comment("日期");
$table->decimal("envitemp1", 9, 2)->nullable(false)->default(0);
$table->decimal("envihumi1", 9, 2)->nullable(false)->default(0);
$table->integer("hour")->nullable(false)->default(0);
$table->integer("num")->nullable(false)->default(1);

});
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('t_hour_TempHumi');
    }
}